package com.hp.demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hp.demo.bean.Product_category;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import org.springframework.stereotype.Service;

import java.util.List;
@Repository
@Mapper
@Service
public interface OrderMapper extends BaseMapper<Product_category> {
    @Select("SELECT * FROM `Product_category` AS pc LEFT JOIN `Product_info` AS pi ON pc.category_type=pi.category_type")
    List<Product_category> getOrder();

}
